﻿<?xml version="1.0" encoding="utf-8" ?>
<settings lookupType="sbda" defaultOrderBy='value'>
  <module>Pacm</module>
  <select>
    text, value, pid,remark
  </select>
  <from>
    (
    select Sblbzd_Lbbh as value,Sblbzd_Lbmc as text,Sblbzd_Sjbh as pid,Sblbzd_Remark as remark from b_Sblbzd
    union all
    select Sbda_Sbbm as value,Sbda_Sbmc as text,Sbda_lbbh as pid ,Sbda_Ggxh as remark from b_Sbda

    ) A
  </from>
  <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
    <field name='value'      cp='startwith'  ></field>
    <field name='text'       cp='like'       ></field>
  </where>
</settings>